Release 10.1A: OpenEdge Data Management:
DataServer for ODBC

Arrays

The OpenEdge database allows you to define fields as arrays, also called field extents. OpenEdge interprets specially named data-source columns of the same data type as an OpenEdge field with the same number of array elements. You must name the data-source columns column-name##1, column-name ##2, and so forth. In Informix, however, you must name these columns column-name__1, column-name __2, and so forth. (Informix does not allow the pound sign (hash sign) in object names.) The DataServer creates a single field definition in the schema holder for the field extents. See the "Adding extended 4GL support" section for instructions on adding these columns automatically with the Progress-to-ODBC utility.